Search - ado excel

[ADO-ODBC] 将ADO数据转换到EXCEL的代码.rar

Description:
Platform: | Size: 77368 | Author: | Hits:

[ADO-ODBC] 1515

Description: Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。 -Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many experts correct.
Platform: | Size: 12983 | Author: 冷寒 | Hits:

[ComboBox] vsprintvsflex8

Description: 用 vsFlexGrid 时，如果用 Add 方法逐个添加数据，跟在 Excel 中用Range()设置单元格的数据一样的慢，所以需要有些技巧，举例来说：在Excel中填写一个数据区域，可以将将要填写进去的数据按单元格的排列事先加入相应的制表符以及回车符号，组合成一个大的字符串，然后帖进去，会很快。 VsFlexGrid 在需要填充的数据多时会比较慢，同样条件的前提下，VB会明显快些！数据加载速度慢可以通过直接绑定ADO的记录集，那样会很快，只是显得没有个性。比如从后台取回的数据是个数字，在前台需要根据这个数字分情况来显示各种不同的字符，如果用RecordSet我不知道怎么搞了。。 vsFlexGrid 的慢是一个问题，也许还比较好避免，也许这并不是他本身的问题，好像很多的控件只要是逐个ADD的都不会快多少，除非用直接绑定！更麻烦的还是从vsFlexGrid到vsPrinter的报表显示显得有点牵强~~，不过常规的报表都还可以应付，象我们的工资明细表、汇总表、储备金汇总、储备金明细、计件工资、花名册、考勤报表乃至工资条等都可以用vsFlexGrid解决，而且能做出比较漂亮的效果，尤其那个表格的合并效果，以及所见所得。。。 -with vsFlexGrid, when used individually Add method to add data with Excel using Range () set up the cell for the same data slow, there is a need in some skills, for example : Excel to fill in a data area can be filled out to be of the data into cells with the prior joining the corresponding tabs and carriage return symbols, as a large portfolio of strings, and then into TIE will soon. VsFlexGrid need to fill in the data for some time will be relatively slow and the same conditions, under the premise of VB will be significantly faster! Data loading slow through direct bonding ADO record set, as it will soon, it is not personality. For example, to recover from the background information is in the number of prospects according to the breakdown of the figures to show a variety of characters, i
Platform: | Size: 602351 | Author: 胡先生 | Hits:

[ADO-ODBC] Myc_ADO

Description: 利用ADO技术连接MSSQL数据库，并利用OLE技术将数据导入到EXCEL中的源程序。-ADO technology connectivity MSSQL database using OLE data into Excel to the source.
Platform: | Size: 17588 | Author: 周瑞 | Hits:

[File Operate] ADO_char

Description: ADO连接数据库字符串大全，（VP,Excel,文本,Sybase,.NET等)。This page contains sample ADO connection strings for ODBC DSN / DSN-Less, OLE DB Providers, Remote Data Services (RDS), MS Remote, MS DataShape. -ADO to connect to the database string Daquan, (VP, Excel, text, Sybase, .NET, etc.). This page contains sample ADO connection strin gs for ODBC DSN / DSN-Less, OLE DB Providers. Remote Data Services (RDS), MS Remote, MS DataShape.
Platform: | Size: 26388 | Author: kk | Hits:

[Other resource] 1

Description: 利用ado控件访问SQL数据库，把数据显示在EXCEL表中，实现历史数据的查询与打印
Platform: | Size: 68074 | Author: 刘与 | Hits:

[Other resource] Excelbyvc

Description: 针对Excel表格文件操作的编程实现，没有采用ADO，只适用于小型程序
Platform: | Size: 107770 | Author: 杨博 | Hits:

[Other resource] Report

Description: .net中word的扩展应用。用ado.net对word,excel进行存取_ADO.NET应用
Platform: | Size: 197590 | Author: maoqun | Hits:

[ADO-ODBC] TagTest

Description: 该程序是一个生产测试软件，功能是通过无线发送命令测试一款电子产品。包含批量测试和散量测试两种模式。散量测试强调操作的便捷性，批量测试则包含用户注册、生成测试记录、重复测试记录检查、生成测试Excel报告等功能。该程序包含VC平台下的典型技术，包含列表、选项卡等常用控件的使用。包含伸缩对话框、自定义按钮等技术。该程序使用ADO技术实现存储测试记录并防止重复测试的功能。其中通过将字符串转化成数字的方法（有点相当于哈希函数的技术），实现了高效的插入和查找。改程序还实现了对Excel的操作，能够自动生成测试报告。包含了典型的启动Excel程序、编辑Excle、使用ADO查找Excle等技术。
Platform: | Size: 158411 | Author: 廖志鹏 | Hits:

[File Operate] OperateExcelFile

Description: 使用ADO 的方式访问和操作excel 文件，里面加入了对 excel 的二次开发的操作
Platform: | Size: 30429 | Author: wang7890 | Hits:

[Other] excelado

Description: 用ado的方式对excel进行操作，可以不用安装office。不用担心excel.dll的版本问题。
Platform: | Size: 181833 | Author: duanjinquan | Hits:

[Other resource] Project1dpr

Description: 本人原创（delphi程序设计提高与应用）源码。本实例利用ADO组件与Access数据库连接，并可将其中的数据表中的数据生成word报表及Excel文件。源码中几乎所有的步骤都有详尽的说明，是delphi初级数据库编程人员快速进入状态的实用案例。
Platform: | Size: 418241 | Author: ybs9999 | Hits:

[CSharp] converToExcel

Description: delphi2005+C#精彩编程实例集锦\\源代码\\第7章 ADO.NET数据访问编程实例\\实例178 如何将记录转换成Excel文件
Platform: | Size: 10394 | Author: 贝比妮 | Hits:

[Other] VCMultiClass

Description: VC各种综合类的设计，包含有：菜单类、操作Excel类、ADO、打印等等。
Platform: | Size: 570794 | Author: cheng | Hits:

[ADO-ODBC] EXCEL_Operator

Description: Excel表格是输入输出经常需要涉及到的。操作Excel表格的方式也多种多样。比如，通过调用Excel程序的COM组件对Excel进行操作。但是，这种方式限制较多，且实现难度比较大。但是，用于访问数据库的组件ADO，是支持多种数据源的，其中就包括Excel文件。我们可以通过ADO组件对Excel文件进行读写访问。当然，在.NET平台上对应ADO数据访问组件的是ADO.NET组件。我编写的这个类就是通过ADO.NET实现了Excel文件的读写。由于时间仓促，功能还不是很完善，会在以后有时间的时候进行版本升级。也请各位高手多多批评指正。-Excel spreadsheet input and output is often of the need to address. Operation Excel variety of ways. For example, by calling the Excel COM procedures for the operation of Excel. However, this approach is more limited and more difficult to achieve. However, for access to the database components ADO, is to support multiple data sources, including Excel file. We can ADO components to read and write Excel files visit. Of course,.NET platform counterparts ADO data access components of ADO.NET components. I prepared this category is achieved through ADO.NET read and write Excel files. Because time is so short, the function is still not perfect, will in future have the time for version upgrades. Members also criticized many experts correct.
Platform: | Size: 4863 | Author: 张雪涛 | Hits:

[Other] VB_IFIX_EXCEL打印报表

Description: VB经过ADO读工控组软件IFIX数据，传至EXCEL生成报表，并打印。-VB After reading software IFIX Industrial Group, send Excel generated statements, and print.
Platform: | Size: 5232 | Author: 利定任 | Hits:

[Delphi VCL] FastReport.v4.7.49

Description:

Current version
---------------
+ added confirmation reading for TfrxMailExport
+ added TimeOut field to TfrxMailExport form
- fixed bug whih PDF export in Delphi4 and CBuilder4
- fixed bug with some codepage which use two bytes for special symbols (Japanese ans Chinese codepages)
- fixed bug when engine delete first space from text in split Memo
+ added ability to use keeping(KeepTogether/KeepChild/KeepHeader) in multi-column report
- fixed bug in multi-column page when band overlap stretched PageHeader
- fixed bug with using ReprintOnNewPage
+ added ability to split big bands(biggest than page height) by default

version 4.7
---------------
+ CodeGear RAD Studio (Delphi/C++Builder) 2009 support
+ [enterprise] enchanced error description in logs
+ added properties TfrxHTMLExport.HTMLDocumentBegin: TStrings,
TfrxHTMLExport.HTMLDocumentBody: TStrings, TfrxHTMLExport.HTMLDocumentEnd: TStrings
+ improved RTF export (with line spacing, vertical gap etc)
+ added support of Enhanced Metafile (EMF) images in Rich Text (RTF), Open Office (ODS), Excel (XLS) exports
+ added OnAfterScriptCompile event
+ added onLoadRecentFile Event
+ added C++ Builder demos
+ added hot-key Ctrl + mouseWheel - Change scale in designer
+ added TfrxMemoView.AnsiText property
- fixed bug in RTF export with EMF pictures in OpenOffice Writer
- fixed some multi-thread isuues in engine, PDF, ODF exports
- [enterprise] fixed integrated template of report navigator
- [enterprise] fixed bug with export in Internet Explorer browser
- fixed bug with font size of dot-matix reports in Excel and XML exports
- fixed bug in e-mail export with many addresses
- fixed bug in XLS export (with fast export unchecked and image object is null)
- [enterprise] fixed bug in TfrxReportServer.OnGetVariables event
- fixed bug in Calcl function
- fixed memory leak in Cross editor
- fixed progress bar and find dialog bug in DualView
- fixed bug in PostNET and ean13 barcodes
- fixed bug with TruncOutboundText in Dot Matrix report
- fixed bugs with break points in syntaxis memo
- improved BeforeConnect event in ADO
- fixed bug in inhehited report with internal dataset
- fixed bug in TfrxPanelControl with background color(Delphi 2005 and above)

经查证后，这个是最新的 FastReport.v4.7.49

Platform: | Size: 2986536 | Author: gzhubin | Hits:

Category

Source Code

Web/Internet

Develop Tools

Document

Other

Search in results

OS

Platform

Language

File Type

Search list